Pandas Profiling Report

Dataset statistics

Number of variables	53
Number of observations	180519
Missing cells	336209
Missing cells (%)	3.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	333.7 MiB
Average record size in memory	1.9 KiB

Variable types

NUM	25
CAT	24
BOOL	2
URL	1
UNSUPPORTED	1

Reproduction

Analysis started	2020-04-08 07:35:13.153937
Analysis finished	2020-04-08 07:54:11.098164
Version	pandas-profiling v2.5.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

`Customer City` has a high cardinality: 563 distinct values	High cardinality
`Customer Fname` has a high cardinality: 782 distinct values	High cardinality
`Customer Lname` has a high cardinality: 1109 distinct values	High cardinality
`Customer Street` has a high cardinality: 7458 distinct values	High cardinality
`Order City` has a high cardinality: 3597 distinct values	High cardinality
`Order Country` has a high cardinality: 164 distinct values	High cardinality
`order date (DateOrders)` has a high cardinality: 65752 distinct values	High cardinality
`Order State` has a high cardinality: 1089 distinct values	High cardinality
`Product Name` has a high cardinality: 118 distinct values	High cardinality
`shipping date (DateOrders)` has a high cardinality: 63701 distinct values	High cardinality
`Longitude` is highly correlated with `Customer Zipcode`	High Correlation
`Customer Zipcode` is highly correlated with `Longitude`	High Correlation
`Order Customer Id` is highly correlated with `Customer Id`	High Correlation
`Customer Id` is highly correlated with `Order Customer Id`	High Correlation
`Order Item Cardprod Id` is highly correlated with `Category Id` and 3 other fields	High Correlation
`Category Id` is highly correlated with `Order Item Cardprod Id` and 2 other fields	High Correlation
`Department Id` is highly correlated with `Order Item Cardprod Id` and 1 other fields	High Correlation
`Order Item Id` is highly correlated with `Order Id`	High Correlation
`Order Id` is highly correlated with `Order Item Id`	High Correlation
`Sales` is highly correlated with `Sales per customer` and 1 other fields	High Correlation
`Sales per customer` is highly correlated with `Sales` and 1 other fields	High Correlation
`Order Item Total` is highly correlated with `Sales per customer` and 1 other fields	High Correlation
`Order Profit Per Order` is highly correlated with `Benefit per order`	High Correlation
`Benefit per order` is highly correlated with `Order Profit Per Order`	High Correlation
`Product Card Id` is highly correlated with `Category Id` and 3 other fields	High Correlation
`Product Category Id` is highly correlated with `Category Id` and 2 other fields	High Correlation
`Product Price` is highly correlated with `Order Item Product Price`	High Correlation
`Order Item Product Price` is highly correlated with `Product Price`	High Correlation
`Customer State` is highly correlated with `Customer Country`	High Correlation
`Customer Country` is highly correlated with `Customer State`	High Correlation
`Department Name` is highly correlated with `Category Name`	High Correlation
`Category Name` is highly correlated with `Department Name`	High Correlation
`Order Region` is highly correlated with `Market`	High Correlation
`Market` is highly correlated with `Order Region`	High Correlation
`Order Status` is highly correlated with `Type`	High Correlation
`Type` is highly correlated with `Order Status`	High Correlation
`Shipping Mode` is highly correlated with `Days for shipment (scheduled)`	High Correlation
`Days for shipment (scheduled)` is highly correlated with `Shipping Mode`	High Correlation
`Order Zipcode` has 155679 (86.2%) missing values	Missing
`Product Description` has 180519 (100.0%) missing values	Missing
`Product Description` is an unsupported type, check if it needs cleaning or further analysis	Rejected
`Days for shipping (real)` has 5080 (2.8%) zeros	Zeros
`Order Item Discount` has 10028 (5.6%) zeros	Zeros
`Order Item Discount Rate` has 10028 (5.6%) zeros	Zeros

Type
Categorical

HIGH CORRELATION

Distinct count	4
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

DEBIT	69295
TRANSFER	49883
PAYMENT	41725
CASH	19616

Value	Count	Frequency (%)
DEBIT	69295	38.4%
TRANSFER	49883	27.6%
PAYMENT	41725	23.1%
CASH	19616	10.9%

Length

Max length	8
Mean length	6.182606817
Min length	4

Value	Count	Frequency (%)
Uppercase_Letter	15	100.0%

Value	Count	Frequency (%)
Latin	15	100.0%

Value	Count	Frequency (%)
ASCII	15	100.0%

Days for shipping (real)
Real number (ℝ_≥0)

ZEROS

Distinct count	7
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.497653987
Minimum	0
Maximum	6
Zeros	5080
Zeros (%)	2.8%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.623721828
Coefficient of variation (CV)	0.464231692
Kurtosis	-1.007913583
Mean	3.497653987
Median Absolute Deviation (MAD)	1.423770874
Skewness	0.084771273
Sum	631393
Variance	2.636472576

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 5.5 6. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2	56618	31.4%
3	28765	15.9%
6	28723	15.9%
4	28513	15.8%
5	28163	15.6%
0	5080	2.8%
1	4657	2.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5080	2.8%
1	4657	2.6%
2	56618	31.4%
3	28765	15.9%
4	28513	15.8%

Value	Count	Frequency (%)
6	28723	15.9%
5	28163	15.6%
4	28513	15.8%
3	28765	15.9%
2	56618	31.4%

Days for shipment (scheduled)
Categorical

HIGH CORRELATION

Distinct count	4
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

4	107752
2	35216
1	27814
0	9737

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

Length

Max length	1
Mean length	1
Min length	1

Value	Count	Frequency (%)
Decimal_Number	4	100.0%

Value	Count	Frequency (%)
Common	4	100.0%

Value	Count	Frequency (%)
ASCII	4	100.0%

Benefit per order
Real number (ℝ)

HIGH CORRELATION

Distinct count	21998
Unique (%)	12.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	21.97498864
Minimum	-4274.97998
Maximum	911.7999878
Zeros	1177
Zeros (%)	0.7%
Memory size	1.4 MiB

Quantile statistics

Minimum	-4274.97998
5-th percentile	-139.2509994
Q1	7
median	31.52000046
Q3	64.80000305
95-th percentile	132.2899933
Maximum	911.7999878
Range	5186.779968
Interquartile range (IQR)	57.80000305

Descriptive statistics

Standard deviation	104.4335257
Coefficient of variation (CV)	4.752381331
Kurtosis	71.37725866
Mean	21.97498864
Median Absolute Deviation (MAD)	56.08869441
Skewness	-4.74183407
Sum	3966902.974
Variance	10906.3613

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[-4274.97998 -1355.61499 -1083.169983 -824.94000245 -674.98498535 ... 239.8199997 240.19000245 245.32499695 720.9499817 911.7999878 ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	1177	0.7%
143.9900055	199	0.1%
72	194	0.1%
46.79999924	188	0.1%
24	181	0.1%
18	175	0.1%
63.70000076	172	0.1%
62.40000153	168	0.1%
14.39999962	166	0.1%
12	166	0.1%
Other values (21988)	177733	98.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4274.97998	1	< 0.1%
-3442.5	1	< 0.1%
-3366	1	< 0.1%
-3000	1	< 0.1%
-2592	1	< 0.1%

Value	Count	Frequency (%)
911.7999878	1	< 0.1%
864	1	< 0.1%
721.5999756	1	< 0.1%
720.2999878	1	< 0.1%
720	2	< 0.1%

Sales per customer
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	2927
Unique (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	183.1076085
Minimum	7.489999771
Maximum	1939.98999
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	7.489999771
5-th percentile	41.5
Q1	104.3799973
median	163.9900055
Q3	247.3999939
95-th percentile	383.980011
Maximum	1939.98999
Range	1932.49999
Interquartile range (IQR)	143.0199966

Descriptive statistics

Standard deviation	120.04367
Coefficient of variation (CV)	0.6555908354
Kurtosis	23.92036151
Mean	183.1076085
Median Absolute Deviation (MAD)	87.66090517
Skewness	2.888446057
Sum	33054402.38
Variance	14410.48271

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 7.48999977 8.43000031 8.48000002 8.57499981 8.67499971 ... 1057.4949951 1215. 1492.494995 1549.994995 1939.98999 ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
122.8399963	1264	0.7%
109.1900024	1247	0.7%
114.3899994	1243	0.7%
113.0899963	1243	0.7%
129.9900055	1243	0.7%
126.0899963	1243	0.7%
107.8899994	1243	0.7%
123.4899979	1243	0.7%
97.48999786	1243	0.7%
110.4899979	1243	0.7%
Other values (2917)	168064	93.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7.489999771	3	< 0.1%
7.989999771	3	< 0.1%
8.18999958	3	< 0.1%
8.289999962	3	< 0.1%
8.390000343	3	< 0.1%

Value	Count	Frequency (%)
1939.98999	1	< 0.1%
1919.98999	1	< 0.1%
1899.98999	1	< 0.1%
1889.98999	1	< 0.1%
1859.98999	1	< 0.1%

Delivery Status
Categorical

Distinct count	4
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Late delivery	98977
Advance shipping	41592
Shipping on time	32196
Shipping canceled	7754

Value	Count	Frequency (%)
Late delivery	98977	54.8%
Advance shipping	41592	23.0%
Shipping on time	32196	17.8%
Shipping canceled	7754	4.3%

Length

Max length	17
Mean length	14.39807998
Min length	13

Value	Count	Frequency (%)
Lowercase_Letter	17	81.0%
Uppercase_Letter	3	14.3%
Space_Separator	1	4.8%

Value	Count	Frequency (%)
Latin	20	95.2%
Common	1	4.8%

Value	Count	Frequency (%)
ASCII	21	100.0%

Late_delivery_risk
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

1	98977
0	81542

Frequency Table

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

Category Id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	51
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	31.85145054
Minimum	2
Maximum	76
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	2
5-th percentile	9
Q1	18
median	29
Q3	45
95-th percentile	48
Maximum	76
Range	74
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	15.64006388
Coefficient of variation (CV)	0.4910314481
Kurtosis	-0.6032610083
Mean	31.85145054
Median Absolute Deviation (MAD)	13.94913209
Skewness	0.3616247994
Sum	5749792
Variance	244.6115983

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 2. 2.5 3.5 4.5 6.5 ... 72.5 73.5 74.5 75.5 76. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
17	24551	13.6%
18	22246	12.3%
24	21035	11.7%
46	19298	10.7%
45	17325	9.6%
48	15540	8.6%
43	13729	7.6%
9	12487	6.9%
29	10984	6.1%
37	2029	1.1%
Other values (41)	21295	11.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	138	0.1%
3	632	0.4%
4	67	< 0.1%
5	343	0.2%
6	328	0.2%

Value	Count	Frequency (%)
76	650	0.4%
75	838	0.5%
74	529	0.3%
73	357	0.2%
72	492	0.3%

Category Name
Categorical

HIGH CORRELATION

Distinct count	50
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Cleats	24551
Men's Footwear	22246
Women's Apparel	21035
Indoor/Outdoor Games	19298
Fishing	17325
Other values (45)	76064

Value	Count	Frequency (%)
Cleats	24551	13.6%
Men's Footwear	22246	12.3%
Women's Apparel	21035	11.7%
Indoor/Outdoor Games	19298	10.7%
Fishing	17325	9.6%
Water Sports	15540	8.6%
Camping & Hiking	13729	7.6%
Cardio Equipment	12487	6.9%
Shop By Sport	10984	6.1%
Electronics	3156	1.7%
Other values (40)	20168	11.2%

Length

Max length	20
Mean length	12.70779253
Min length	4

Value	Count	Frequency (%)
Lowercase_Letter	24	49.0%
Uppercase_Letter	19	38.8%
Other_Punctuation	4	8.2%
Dash_Punctuation	1	2.0%
Space_Separator	1	2.0%

Value	Count	Frequency (%)
Latin	43	87.8%
Common	6	12.2%

Value	Count	Frequency (%)
ASCII	49	100.0%

Customer City
Categorical

HIGH CARDINALITY

Distinct count	563
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Caguas	66770
Chicago	3885
Los Angeles	3417
Brooklyn	3412
New York	1816
Other values (558)	101219

Value	Count	Frequency (%)
Caguas	66770	37.0%
Chicago	3885	2.2%
Los Angeles	3417	1.9%
Brooklyn	3412	1.9%
New York	1816	1.0%
Philadelphia	1577	0.9%
Bronx	1500	0.8%
San Diego	1437	0.8%
Miami	1314	0.7%
Houston	1297	0.7%
Other values (553)	94094	52.1%

Length

Max length	20
Mean length	7.708623469
Min length	2

Value	Count	Frequency (%)
Lowercase_Letter	26	50.0%
Uppercase_Letter	25	48.1%
Space_Separator	1	1.9%

Value	Count	Frequency (%)
Latin	51	98.1%
Common	1	1.9%

Value	Count	Frequency (%)
ASCII	52	100.0%

Customer Country
Categorical

HIGH CORRELATION

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

EE. UU.	111146
Puerto Rico	69373

Value	Count	Frequency (%)
EE. UU.	111146	61.6%
Puerto Rico	69373	38.4%

Length

Max length	11
Mean length	8.537189991
Min length	7

Value	Count	Frequency (%)
Lowercase_Letter	7	53.8%
Uppercase_Letter	4	30.8%
Space_Separator	1	7.7%
Other_Punctuation	1	7.7%

Value	Count	Frequency (%)
Latin	11	84.6%
Common	2	15.4%

Value	Count	Frequency (%)
ASCII	13	100.0%

Customer Email
Categorical

CONSTANT
REJECTED

Distinct count	1
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

XXXXXXXXX	180519

Value	Count	Frequency (%)
XXXXXXXXX	180519	100.0%

Length

Max length	9
Mean length	9
Min length	9

Value	Count	Frequency (%)
Uppercase_Letter	1	100.0%

Value	Count	Frequency (%)
Latin	1	100.0%

Value	Count	Frequency (%)
ASCII	1	100.0%

Customer Fname
Categorical

HIGH CARDINALITY

Distinct count	782
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Mary	65150
James	1835
Robert	1759
Michael	1680
David	1625
Other values (777)	108470

Value	Count	Frequency (%)
Mary	65150	36.1%
James	1835	1.0%
Robert	1759	1.0%
Michael	1680	0.9%
David	1625	0.9%
John	1446	0.8%
William	1365	0.8%
Joseph	1117	0.6%
Jennifer	1033	0.6%
Richard	1032	0.6%
Other values (772)	102477	56.8%

Length

Max length	11
Mean length	5.274658069
Min length	2

Value	Count	Frequency (%)
Lowercase_Letter	26	50.0%
Uppercase_Letter	26	50.0%

Value	Count	Frequency (%)
Latin	52	100.0%

Value	Count	Frequency (%)
ASCII	52	100.0%

Customer Id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	20652
Unique (%)	11.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6691.379495
Minimum	1
Maximum	20757
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	1
5-th percentile	649
Q1	3258.5
median	6457
Q3	9779
95-th percentile	12383
Maximum	20757
Range	20756
Interquartile range (IQR)	6520.5

Descriptive statistics

Standard deviation	4162.918106
Coefficient of variation (CV)	0.6221315215
Kurtosis	0.01489882226
Mean	6691.379495
Median Absolute Deviation (MAD)	3447.119576
Skewness	0.4887682515
Sum	1207921135
Variance	17329887.16

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[1.00000e+00 1.03500e+02 1.22500e+02 1.24500e+02 1.36500e+02 ... 1.24055e+04 1.24305e+04 1.24325e+04 1.24355e+04 2.07570e+04], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
5654	47	< 0.1%
5004	45	< 0.1%
10591	45	< 0.1%
5715	44	< 0.1%
3708	44	< 0.1%
9371	44	< 0.1%
1443	43	< 0.1%
2641	43	< 0.1%
791	43	< 0.1%
12284	43	< 0.1%
Other values (20642)	180078	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	10	< 0.1%
3	18	< 0.1%
4	14	< 0.1%
5	7	< 0.1%

Value	Count	Frequency (%)
20757	1	< 0.1%
20756	1	< 0.1%
20755	1	< 0.1%
20754	1	< 0.1%
20753	1	< 0.1%

Customer Lname
Categorical

HIGH CARDINALITY

Distinct count	1109
Unique (%)	0.6%
Missing	8
Missing (%)	< 0.1%
Memory size	1.4 MiB

Smith	64104
Johnson	989
Brown	909
Williams	869
Jones	859
Other values (1104)	112781

Value	Count	Frequency (%)
Smith	64104	35.5%
Johnson	989	0.5%
Brown	909	0.5%
Williams	869	0.5%
Jones	859	0.5%
Garcia	724	0.4%
Wilson	675	0.4%
Taylor	661	0.4%
Davis	640	0.4%
Moore	599	0.3%
Other values (1099)	109482	60.6%

Length

Max length	12
Mean length	5.712290673
Min length	2

Value	Count	Frequency (%)
Lowercase_Letter	26	51.0%
Uppercase_Letter	25	49.0%

Value	Count	Frequency (%)
Latin	51	100.0%

Value	Count	Frequency (%)
ASCII	51	100.0%

Customer Password
Categorical

CONSTANT
REJECTED

Distinct count	1
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

XXXXXXXXX	180519

Value	Count	Frequency (%)
XXXXXXXXX	180519	100.0%

Length

Max length	9
Mean length	9
Min length	9

Value	Count	Frequency (%)
Uppercase_Letter	1	100.0%

Value	Count	Frequency (%)
Latin	1	100.0%

Value	Count	Frequency (%)
ASCII	1	100.0%

Customer Segment
Categorical

Distinct count	3
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Consumer	93504
Corporate	54789
Home Office	32226

Value	Count	Frequency (%)
Consumer	93504	51.8%
Corporate	54789	30.4%
Home Office	32226	17.9%

Length

Max length	11
Mean length	8.839064032
Min length	8

Value	Count	Frequency (%)
Lowercase_Letter	13	76.5%
Uppercase_Letter	3	17.6%
Space_Separator	1	5.9%

Value	Count	Frequency (%)
Latin	16	94.1%
Common	1	5.9%

Value	Count	Frequency (%)
ASCII	17	100.0%

Customer State
Categorical

HIGH CORRELATION

Distinct count	46
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

PR	69373
CA	29223
NY	11327
TX	9103
IL	7631
Other values (41)	53862

Value	Count	Frequency (%)
PR	69373	38.4%
CA	29223	16.2%
NY	11327	6.3%
TX	9103	5.0%
IL	7631	4.2%
FL	5456	3.0%
OH	4095	2.3%
PA	3824	2.1%
MI	3804	2.1%
NJ	3191	1.8%
Other values (36)	33492	18.6%

Length

Max length	5
Mean length	2.000049856
Min length	2

Value	Count	Frequency (%)
Uppercase_Letter	24	77.4%
Decimal_Number	7	22.6%

Value	Count	Frequency (%)
Latin	24	77.4%
Common	7	22.6%

Value	Count	Frequency (%)
ASCII	31	100.0%

Customer Street
Categorical

HIGH CARDINALITY

Distinct count	7458
Unique (%)	4.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

9126 Wishing Expressway	122
4388 Burning Goose Ridge	117
4720 Noble Hills Wynd	116
2878 Hazy Wagon Thicket	113
398 Emerald Grove	109
Other values (7453)	179942

Value	Count	Frequency (%)
9126 Wishing Expressway	122	0.1%
4388 Burning Goose Ridge	117	0.1%
4720 Noble Hills Wynd	116	0.1%
2878 Hazy Wagon Thicket	113	0.1%
398 Emerald Grove	109	0.1%
3593 Blue Brook Acres	108	0.1%
6289 Rocky Way	107	0.1%
2210 Merry Leaf Row	107	0.1%
2585 Silent Autumn Landing	105	0.1%
141 Dewy Plaza	103	0.1%
Other values (7448)	179412	99.4%

Length

Max length	33
Mean length	19.95711255
Min length	8

Value	Count	Frequency (%)
Lowercase_Letter	25	41.0%
Uppercase_Letter	24	39.3%
Decimal_Number	10	16.4%
Dash_Punctuation	1	1.6%
Space_Separator	1	1.6%

Value	Count	Frequency (%)
Latin	49	80.3%
Common	12	19.7%

Value	Count	Frequency (%)
ASCII	61	100.0%

Customer Zipcode
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	995
Unique (%)	0.6%
Missing	3
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	35921.12691
Minimum	603
Maximum	99205
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	603
5-th percentile	725
Q1	725
median	19380
Q3	78207
95-th percentile	94538
Maximum	99205
Range	98602
Interquartile range (IQR)	77482

Descriptive statistics

Standard deviation	37542.46112
Coefficient of variation (CV)	1.045135951
Kurtosis	-1.451419372
Mean	35921.12691
Median Absolute Deviation (MAD)	34305.8828
Skewness	0.4908834095
Sum	6484338146
Variance	1409436387

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
725	66770	37.0%
921	337	0.2%
23455	334	0.2%
957	297	0.2%
79109	292	0.2%
33324	283	0.2%
80012	280	0.2%
33624	261	0.1%
92115	256	0.1%
92024	254	0.1%
Other values (985)	111152	61.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
603	50	< 0.1%
612	122	0.1%
674	169	0.1%
680	133	0.1%
685	126	0.1%

Value	Count	Frequency (%)
99205	43	< 0.1%
98632	67	< 0.1%
98390	28	< 0.1%
98226	47	< 0.1%
98208	95	0.1%

Department Id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	11
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.443460245
Minimum	2
Maximum	12
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	4
median	5
Q3	7
95-th percentile	7
Maximum	12
Range	10
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.629246035
Coefficient of variation (CV)	0.2993033772
Kurtosis	-0.1816965071
Mean	5.443460245
Median Absolute Deviation (MAD)	1.43459705
Skewness	0.2733206291
Sum	982648
Variance	2.654442643

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 2. 3.5 4.5 5.5 6.5 ... 8.5 9.5 10.5 11.5 12. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
7	66861	37.0%
4	48998	27.1%
5	33220	18.4%
3	14525	8.0%
6	9686	5.4%
2	2479	1.4%
9	2026	1.1%
10	1465	0.8%
11	492	0.3%
8	405	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	2479	1.4%
3	14525	8.0%
4	48998	27.1%
5	33220	18.4%
6	9686	5.4%

Value	Count	Frequency (%)
12	362	0.2%
11	492	0.3%
10	1465	0.8%
9	2026	1.1%
8	405	0.2%

Department Name
Categorical

HIGH CORRELATION

Distinct count	11
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Fan Shop	66861
Apparel	48998
Golf	33220
Footwear	14525
Outdoors	9686
Other values (6)	7229

Value	Count	Frequency (%)
Fan Shop	66861	37.0%
Apparel	48998	27.1%
Golf	33220	18.4%
Footwear	14525	8.0%
Outdoors	9686	5.4%
Fitness	2479	1.4%
Discs Shop	2026	1.1%
Technology	1465	0.8%
Pet Shop	492	0.3%
Book Shop	405	0.2%

Length

Max length	18
Mean length	7.039713271
Min length	4

Value	Count	Frequency (%)
Lowercase_Letter	19	63.3%
Uppercase_Letter	10	33.3%
Space_Separator	1	3.3%

Value	Count	Frequency (%)
Latin	29	96.7%
Common	1	3.3%

Value	Count	Frequency (%)
ASCII	30	100.0%

Latitude
Real number (ℝ)

Distinct count	11250
Unique (%)	6.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	29.71995466
Minimum	-33.93755341
Maximum	48.78193283
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	-33.93755341
5-th percentile	18.21293068
Q1	18.26543236
median	33.14486313
Q3	39.27961731
95-th percentile	42.39110184
Maximum	48.78193283
Range	82.71948624
Interquartile range (IQR)	21.01418495

Descriptive statistics

Standard deviation	9.813646327
Coefficient of variation (CV)	0.3302039468
Kurtosis	-1.555414897
Mean	29.71995466
Median Absolute Deviation (MAD)	9.089862493
Skewness	-0.09796266623
Sum	5365016.496
Variance	96.30765423

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[-33.93755341 -7.97753143 17.99465561 18.02520657 18.02536583 ... 47.91032028 47.91926957 48.3484974 48.77644539 48.78193283], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
18.2275734	417	0.2%
39.49591446	370	0.2%
18.22757721	300	0.2%
36.91083145	280	0.2%
26.0984993	270	0.1%
18.38011932	267	0.1%
33.04647064	234	0.1%
32.75856018	218	0.1%
26.21472931	218	0.1%
40.64759827	212	0.1%
Other values (11240)	177733	98.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-33.93755341	9	< 0.1%
17.98249054	38	< 0.1%
18.00682068	22	< 0.1%
18.01836205	20	< 0.1%
18.02520371	17	< 0.1%

Value	Count	Frequency (%)
48.78193283	6	< 0.1%
48.77095795	41	< 0.1%
47.92603684	7	< 0.1%
47.91250229	4	< 0.1%
47.90813828	20	< 0.1%

Longitude
Real number (ℝ)

HIGH CORRELATION

Distinct count	4487
Unique (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-84.91567469
Minimum	-158.0259857
Maximum	115.2630768
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	-158.0259857
5-th percentile	-121.435112
Q1	-98.44631195
median	-76.84790802
Q3	-66.37058258
95-th percentile	-66.18312836
Maximum	115.2630768
Range	273.2890625
Interquartile range (IQR)	32.07572937

Descriptive statistics

Standard deviation	21.4332412
Coefficient of variation (CV)	-0.2524061815
Kurtosis	2.180982226
Mean	-84.91567469
Median Absolute Deviation (MAD)	17.88808103
Skewness	-0.4984610726
Sum	-15328892.68
Variance	459.3838283

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[-158.0259857 -158.0131302 -158.00472255 -158.0046539 -157.9979477 ... 47.83176613 79.77704621 83.60233688 115.1564331 115.2630768 ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
-66.3706131	3821	2.1%
-66.37057495	3523	2.0%
-66.37059021	3522	2.0%
-66.37050629	3465	1.9%
-66.37055206	3417	1.9%
-66.37052918	3408	1.9%
-66.3705368	3377	1.9%
-66.37055969	3242	1.8%
-66.37060547	3230	1.8%
-66.37058258	3155	1.7%
Other values (4477)	146359	81.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-158.0259857	73	< 0.1%
-158.016037	134	0.1%
-158.0102234	18	< 0.1%
-158.0047607	7	< 0.1%
-158.0046844	43	< 0.1%

Value	Count	Frequency (%)
115.2630768	17	< 0.1%
115.0497894	17	< 0.1%
84.74267578	8	< 0.1%
82.46199799	22	< 0.1%
77.09209442	32	< 0.1%

Market
Categorical

HIGH CORRELATION

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

LATAM	51594
Europe	50252
Pacific Asia	41260
USCA	25799
Africa	11614

Value	Count	Frequency (%)
LATAM	51594	28.6%
Europe	50252	27.8%
Pacific Asia	41260	22.9%
USCA	25799	14.3%
Africa	11614	6.4%

Length

Max length	12
Mean length	6.799738532
Min length	4

Value	Count	Frequency (%)
Lowercase_Letter	10	50.0%
Uppercase_Letter	9	45.0%
Space_Separator	1	5.0%

Value	Count	Frequency (%)
Latin	19	95.0%
Common	1	5.0%

Value	Count	Frequency (%)
ASCII	20	100.0%

Order City
Categorical

HIGH CARDINALITY

Distinct count	3597
Unique (%)	2.0%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Santo Domingo	2211
New York City	2202
Los Angeles	1845
Tegucigalpa	1783
Managua	1682
Other values (3592)	170796

Value	Count	Frequency (%)
Santo Domingo	2211	1.2%
New York City	2202	1.2%
Los Angeles	1845	1.0%
Tegucigalpa	1783	1.0%
Managua	1682	0.9%
Mexico City	1484	0.8%
Manila	1381	0.8%
Philadelphia	1302	0.7%
San Francisco	1297	0.7%
London	1187	0.7%
Other values (3587)	164145	90.9%

Length

Max length	35
Mean length	8.55421313
Min length	2

Value	Count	Frequency (%)
Lowercase_Letter	42	53.2%
Uppercase_Letter	29	36.7%
Other_Punctuation	3	3.8%
Dash_Punctuation	1	1.3%
Space_Separator	1	1.3%
Close_Punctuation	1	1.3%
Open_Punctuation	1	1.3%
Control	1	1.3%

Value	Count	Frequency (%)
Latin	71	89.9%
Common	8	10.1%

Value	Count	Frequency (%)
ASCII	59	100.0%

Order Country
Categorical

HIGH CARDINALITY

Distinct count	164
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Estados Unidos	24840
Francia	13222
México	13172
Alemania	9564
Australia	8497
Other values (159)	111224

Value	Count	Frequency (%)
Estados Unidos	24840	13.8%
Francia	13222	7.3%
México	13172	7.3%
Alemania	9564	5.3%
Australia	8497	4.7%
Brasil	7987	4.4%
Reino Unido	7302	4.0%
China	5758	3.2%
Italia	4989	2.8%
India	4783	2.6%
Other values (154)	80405	44.5%

Length

Max length	31
Mean length	8.772827237
Min length	4

Value	Count	Frequency (%)
Lowercase_Letter	32	52.5%
Uppercase_Letter	25	41.0%
Dash_Punctuation	1	1.6%
Close_Punctuation	1	1.6%
Space_Separator	1	1.6%
Open_Punctuation	1	1.6%

Value	Count	Frequency (%)
Latin	57	93.4%
Common	4	6.6%

Value	Count	Frequency (%)
ASCII	54	100.0%

Order Customer Id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	20652
Unique (%)	11.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6691.379495
Minimum	1
Maximum	20757
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	1
5-th percentile	649
Q1	3258.5
median	6457
Q3	9779
95-th percentile	12383
Maximum	20757
Range	20756
Interquartile range (IQR)	6520.5

Descriptive statistics

Standard deviation	4162.918106
Coefficient of variation (CV)	0.6221315215
Kurtosis	0.01489882226
Mean	6691.379495
Median Absolute Deviation (MAD)	3447.119576
Skewness	0.4887682515
Sum	1207921135
Variance	17329887.16

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5654	47	< 0.1%
5004	45	< 0.1%
10591	45	< 0.1%
5715	44	< 0.1%
3708	44	< 0.1%
9371	44	< 0.1%
1443	43	< 0.1%
2641	43	< 0.1%
791	43	< 0.1%
12284	43	< 0.1%
Other values (20642)	180078	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	10	< 0.1%
3	18	< 0.1%
4	14	< 0.1%
5	7	< 0.1%

Value	Count	Frequency (%)
20757	1	< 0.1%
20756	1	< 0.1%
20755	1	< 0.1%
20754	1	< 0.1%
20753	1	< 0.1%

order date (DateOrders)
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	65752
Unique (%)	36.4%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

11/1/2016 19:01	5
8/5/2015 6:42	5
9/29/2016 16:06	5
9/28/2017 7:53	5
11/18/2016 7:37	5
Other values (65747)	180494

Value	Count	Frequency (%)
11/1/2016 19:01	5	< 0.1%
8/5/2015 6:42	5	< 0.1%
9/29/2016 16:06	5	< 0.1%
9/28/2017 7:53	5	< 0.1%
11/18/2016 7:37	5	< 0.1%
11/19/2015 3:45	5	< 0.1%
9/7/2015 9:59	5	< 0.1%
4/3/2016 14:25	5	< 0.1%
2/18/2015 8:20	5	< 0.1%
7/17/2015 12:30	5	< 0.1%
Other values (65742)	180469	> 99.9%

Length

Max length	16
Mean length	14.49898903
Min length	13

Value	Count	Frequency (%)
Decimal_Number	10	76.9%
Other_Punctuation	2	15.4%
Space_Separator	1	7.7%

Value	Count	Frequency (%)
Common	13	100.0%

Value	Count	Frequency (%)
ASCII	13	100.0%

Order Id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	65752
Unique (%)	36.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	36221.8949
Minimum	1
Maximum	77204
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	1
5-th percentile	3626.8
Q1	18057
median	36140
Q3	54144
95-th percentile	68596
Maximum	77204
Range	77203
Interquartile range (IQR)	36087

Descriptive statistics

Standard deviation	21045.37957
Coefficient of variation (CV)	0.5810126617
Kurtosis	-1.152935673
Mean	36221.8949
Median Absolute Deviation (MAD)	18173.33239
Skewness	0.03270879463
Sum	6538740246
Variance	442908001.2

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[1.00000e+00 6.88835e+04 7.72040e+04], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
30397	5	< 0.1%
16203	5	< 0.1%
42806	5	< 0.1%
49302	5	< 0.1%
60278	5	< 0.1%
62325	5	< 0.1%
40753	5	< 0.1%
47257	5	< 0.1%
67308	5	< 0.1%
26414	5	< 0.1%
Other values (65742)	180469	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	3	< 0.1%
4	4	< 0.1%
5	5	< 0.1%
7	3	< 0.1%

Value	Count	Frequency (%)
77204	1	< 0.1%
77203	1	< 0.1%
77202	1	< 0.1%
77201	1	< 0.1%
77200	1	< 0.1%

Order Item Cardprod Id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	118
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	692.5097635
Minimum	19
Maximum	1363
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	19
5-th percentile	191
Q1	403
median	627
Q3	1004
95-th percentile	1073
Maximum	1363
Range	1344
Interquartile range (IQR)	601

Descriptive statistics

Standard deviation	336.4468073
Coefficient of variation (CV)	0.4858369153
Kurtosis	-1.267493907
Mean	692.5097635
Median Absolute Deviation (MAD)	309.2081086
Skewness	0.1382546099
Sum	125011170
Variance	113196.4542

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 19. 21.5 36. 40.5 51. ... 1359.5 1360.5 1361.5 1362.5 1363. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
365	24515	13.6%
403	22246	12.3%
502	21035	11.7%
1014	19298	10.7%
1004	17325	9.6%
1073	15500	8.6%
957	13729	7.6%
191	12169	6.7%
627	10617	5.9%
1362	838	0.5%
Other values (108)	23247	12.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
19	64	< 0.1%
24	74	< 0.1%
35	65	< 0.1%
37	262	0.1%
44	305	0.2%

Value	Count	Frequency (%)
1363	650	0.4%
1362	838	0.5%
1361	529	0.3%
1360	357	0.2%
1359	492	0.3%

Order Item Discount
Real number (ℝ_≥0)

ZEROS

Distinct count	1017
Unique (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	20.66474112
Minimum	0
Maximum	500
Zeros	10028
Zeros (%)	5.6%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5.400000095
median	14
Q3	29.98999977
95-th percentile	62.5
Maximum	500
Range	500
Interquartile range (IQR)	24.58999968

Descriptive statistics

Standard deviation	21.80090095
Coefficient of variation (CV)	1.054980598
Kurtosis	25.23126719
Mean	20.66474112
Median Absolute Deviation (MAD)	15.68134227
Skewness	3.039795514
Sum	3730378.403
Variance	475.2792824

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0.00000000e+00 5.00000005e-02 1.05000000e-01 1.35000001e-01 2.25000001e-01 ... 2.12500000e+02 3.10000000e+02 3.67500000e+02 3.87500000e+02 5.00000000e+02], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	10028	5.6%
6	4589	2.5%
12	4067	2.3%
4	3647	2.0%
8	3626	2.0%
10	3424	1.9%
36	3268	1.8%
30	3230	1.8%
20	3123	1.7%
9	2964	1.6%
Other values (1007)	138553	76.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10028	5.6%
0.100000001	3	< 0.1%
0.109999999	15	< 0.1%
0.119999997	29	< 0.1%
0.150000006	7	< 0.1%

Value	Count	Frequency (%)
500	1	< 0.1%
400	1	< 0.1%
375	25	< 0.1%
360	1	< 0.1%
340	1	< 0.1%

Order Item Discount Rate
Real number (ℝ_≥0)

ZEROS

Distinct count	18
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1016681906
Minimum	0
Maximum	0.25
Zeros	10028
Zeros (%)	5.6%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.039999999
median	0.100000001
Q3	0.159999996
95-th percentile	0.25
Maximum	0.25
Range	0.25
Interquartile range (IQR)	0.119999997

Descriptive statistics

Standard deviation	0.07041521533
Coefficient of variation (CV)	0.692598294
Kurtosis	-0.9011568627
Mean	0.1016681906
Median Absolute Deviation (MAD)	0.06074039626
Skewness	0.3409276012
Sum	18353.04009
Variance	0.004958302549

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0. 0.005 0.065 0.155 0.175 0.19 0.225 0.25 ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0.159999996	10029	5.6%
0.07	10029	5.6%
0.180000007	10029	5.6%
0.050000001	10029	5.6%
0.039999999	10029	5.6%
0.150000006	10029	5.6%
0.100000001	10029	5.6%
0.129999995	10029	5.6%
0.25	10029	5.6%
0.090000004	10029	5.6%
Other values (8)	80229	44.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	10028	5.6%
0.01	10028	5.6%
0.02	10028	5.6%
0.029999999	10029	5.6%
0.039999999	10029	5.6%

Value	Count	Frequency (%)
0.25	10029	5.6%
0.200000003	10029	5.6%
0.180000007	10029	5.6%
0.170000002	10029	5.6%
0.159999996	10029	5.6%

Order Item Id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct count	180519
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	90260
Minimum	1
Maximum	180519
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	1
5-th percentile	9026.9
Q1	45130.5
median	90260
Q3	135389.5
95-th percentile	171493.1
Maximum	180519
Range	180518
Interquartile range (IQR)	90259

Descriptive statistics

Standard deviation	52111.49096
Coefficient of variation (CV)	0.5773486701
Kurtosis	-1.2
Mean	90260
Median Absolute Deviation (MAD)	45129.75
Skewness	8.455466102e-18
Sum	1.629364494e+10
Variance	2715607490

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[1.00000e+00 1.80519e+05], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2047	1	< 0.1%
79372	1	< 0.1%
144748	1	< 0.1%
134507	1	< 0.1%
132458	1	< 0.1%
138601	1	< 0.1%
136552	1	< 0.1%
159079	1	< 0.1%
157030	1	< 0.1%
163173	1	< 0.1%
Other values (180509)	180509	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
180519	1	< 0.1%
180518	1	< 0.1%
180517	1	< 0.1%
180516	1	< 0.1%
180515	1	< 0.1%

Order Item Product Price
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	75
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	141.2325499
Minimum	9.989999771
Maximum	1999.98999
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	9.989999771
5-th percentile	31.98999977
Q1	50
median	59.99000168
Q3	199.9900055
95-th percentile	399.980011
Maximum	1999.98999
Range	1989.99999
Interquartile range (IQR)	149.9900055

Descriptive statistics

Standard deviation	139.732492
Coefficient of variation (CV)	0.9893788087
Kurtosis	23.31299748
Mean	141.2325499
Median Absolute Deviation (MAD)	102.813998
Skewness	3.19101957
Sum	25495158.68
Variance	19525.16932

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 9.98999977 11.41499996 15.48999977 16.98999977 18.98999977 ... 566.28500365 799.9899902 1249.9949951 1749.994995 1999.98999 ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
59.99000168	24820	13.7%
129.9900055	22372	12.4%
50	21035	11.7%
49.97999954	19298	10.7%
399.980011	17325	9.6%
199.9900055	15622	8.7%
299.980011	13729	7.6%
99.98999786	12433	6.9%
39.99000168	11201	6.2%
24.98999977	2339	1.3%
Other values (65)	20345	11.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
9.989999771	285	0.2%
11.28999996	271	0.2%
11.53999996	529	0.3%
14.98999977	593	0.3%
15.98999977	602	0.3%

Value	Count	Frequency (%)
1999.98999	15	< 0.1%
1500	442	0.2%
999.9899902	10	< 0.1%
599.9899902	21	< 0.1%
532.5800171	484	0.3%

Order Item Profit Ratio
Real number (ℝ)

Distinct count	162
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1206466355
Minimum	-2.75
Maximum	0.5
Zeros	1177
Zeros (%)	0.7%
Memory size	1.4 MiB

Quantile statistics

Minimum	-2.75
5-th percentile	-0.769999981
Q1	0.079999998
median	0.270000011
Q3	0.360000014
95-th percentile	0.479999989
Maximum	0.5
Range	3.25
Interquartile range (IQR)	0.280000016

Descriptive statistics

Standard deviation	0.4667956046
Coefficient of variation (CV)	3.869114151
Kurtosis	10.15722452
Mean	0.1206466355
Median Absolute Deviation (MAD)	0.2941215544
Skewness	-2.893531341
Sum	21779.00999
Variance	0.2178981365

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[-2.75 -2.72500002 -2.67500007 -2.625 -2.47500002 ... 0.465 0.47499999 0.485 0.495 0.5 ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0.479999989	9197	5.1%
0.349999994	7997	4.4%
0.25999999	6577	3.6%
0.340000004	6507	3.6%
0.469999999	6378	3.5%
0.360000014	6108	3.4%
0.330000013	5789	3.2%
0.49000001	5688	3.2%
0.289999992	5478	3.0%
0.280000001	5403	3.0%
Other values (152)	115397	63.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2.75	72	< 0.1%
-2.700000048	252	0.1%
-2.650000095	90	< 0.1%
-2.599999905	181	0.1%
-2.549999952	234	0.1%

Value	Count	Frequency (%)
0.5	2529	1.4%
0.49000001	5688	3.2%
0.479999989	9197	5.1%
0.469999999	6378	3.5%
0.460000008	4822	2.7%

Order Item Quantity
Real number (ℝ_≥0)

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.127637534
Minimum	1
Maximum	5
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	3
95-th percentile	5
Maximum	5
Range	4
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.453451481
Coefficient of variation (CV)	0.6831292728
Kurtosis	-0.7537015772
Mean	2.127637534
Median Absolute Deviation (MAD)	1.267236976
Skewness	0.8802518479
Sum	384079
Variance	2.112521209

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[1. 1.5 4.5 5. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	99134	54.9%
2	20315	11.3%
3	20350	11.3%
4	20335	11.3%
5	20385	11.3%

Value	Count	Frequency (%)
5	20385	11.3%
4	20335	11.3%
3	20350	11.3%
2	20315	11.3%
1	99134	54.9%

Sales
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	193
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	203.7720961
Minimum	9.989999771
Maximum	1999.98999
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	9.989999771
5-th percentile	49.97999954
Q1	119.9800034
median	199.9199982
Q3	299.9500122
95-th percentile	399.980011
Maximum	1999.98999
Range	1989.99999
Interquartile range (IQR)	179.9700088

Descriptive statistics

Standard deviation	132.2730775
Coefficient of variation (CV)	0.649122623
Kurtosis	23.93656127
Mean	203.7720961
Median Absolute Deviation (MAD)	95.94152385
Skewness	2.884249049
Sum	36784735.01
Variance	17496.16703

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 9.98999977 10.63999987 13.26499987 16.98999977 19.98499966 ... 566.28500365 799.9899902 1249.9949951 1749.994995 1999.98999 ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
129.9900055	22372	12.4%
399.980011	17325	9.6%
199.9900055	15622	8.7%
299.980011	13729	7.6%
179.9700012	5016	2.8%
299.9500122	4988	2.8%
119.9800034	4968	2.8%
239.9600067	4955	2.7%
59.99000168	4893	2.7%
50	4432	2.5%
Other values (183)	82219	45.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
9.989999771	56	< 0.1%
11.28999996	271	0.2%
11.53999996	529	0.3%
14.98999977	124	0.1%
15.98999977	118	0.1%

Value	Count	Frequency (%)
1999.98999	15	< 0.1%
1500	442	0.2%
999.9899902	10	< 0.1%
599.9899902	21	< 0.1%
532.5800171	484	0.3%

Order Item Total
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	2927
Unique (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	183.1076085
Minimum	7.489999771
Maximum	1939.98999
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	7.489999771
5-th percentile	41.5
Q1	104.3799973
median	163.9900055
Q3	247.3999939
95-th percentile	383.980011
Maximum	1939.98999
Range	1932.49999
Interquartile range (IQR)	143.0199966

Descriptive statistics

Standard deviation	120.04367
Coefficient of variation (CV)	0.6555908354
Kurtosis	23.92036151
Mean	183.1076085
Median Absolute Deviation (MAD)	87.66090517
Skewness	2.888446057
Sum	33054402.38
Variance	14410.48271

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
122.8399963	1264	0.7%
109.1900024	1247	0.7%
114.3899994	1243	0.7%
113.0899963	1243	0.7%
129.9900055	1243	0.7%
126.0899963	1243	0.7%
107.8899994	1243	0.7%
123.4899979	1243	0.7%
97.48999786	1243	0.7%
110.4899979	1243	0.7%
Other values (2917)	168064	93.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7.489999771	3	< 0.1%
7.989999771	3	< 0.1%
8.18999958	3	< 0.1%
8.289999962	3	< 0.1%
8.390000343	3	< 0.1%

Value	Count	Frequency (%)
1939.98999	1	< 0.1%
1919.98999	1	< 0.1%
1899.98999	1	< 0.1%
1889.98999	1	< 0.1%
1859.98999	1	< 0.1%

Order Profit Per Order
Real number (ℝ)

HIGH CORRELATION

Distinct count	21998
Unique (%)	12.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	21.97498864
Minimum	-4274.97998
Maximum	911.7999878
Zeros	1177
Zeros (%)	0.7%
Memory size	1.4 MiB

Quantile statistics

Minimum	-4274.97998
5-th percentile	-139.2509994
Q1	7
median	31.52000046
Q3	64.80000305
95-th percentile	132.2899933
Maximum	911.7999878
Range	5186.779968
Interquartile range (IQR)	57.80000305

Descriptive statistics

Standard deviation	104.4335257
Coefficient of variation (CV)	4.752381331
Kurtosis	71.37725866
Mean	21.97498864
Median Absolute Deviation (MAD)	56.08869441
Skewness	-4.74183407
Sum	3966902.974
Variance	10906.3613

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	1177	0.7%
143.9900055	199	0.1%
72	194	0.1%
46.79999924	188	0.1%
24	181	0.1%
18	175	0.1%
63.70000076	172	0.1%
62.40000153	168	0.1%
14.39999962	166	0.1%
12	166	0.1%
Other values (21988)	177733	98.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4274.97998	1	< 0.1%
-3442.5	1	< 0.1%
-3366	1	< 0.1%
-3000	1	< 0.1%
-2592	1	< 0.1%

Value	Count	Frequency (%)
911.7999878	1	< 0.1%
864	1	< 0.1%
721.5999756	1	< 0.1%
720.2999878	1	< 0.1%
720	2	< 0.1%

Order Region
Categorical

HIGH CORRELATION

Distinct count	23
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Central America	28341
Western Europe	27109
South America	14935
Oceania	10148
Northern Europe	9792
Other values (18)	90194

Value	Count	Frequency (%)
Central America	28341	15.7%
Western Europe	27109	15.0%
South America	14935	8.3%
Oceania	10148	5.6%
Northern Europe	9792	5.4%
Southeast Asia	9539	5.3%
Southern Europe	9431	5.2%
Caribbean	8318	4.6%
West of USA	7993	4.4%
South Asia	7731	4.3%
Other values (13)	47182	26.1%

Length

Max length	15
Mean length	12.63430442
Min length	6

Value	Count	Frequency (%)
Lowercase_Letter	17	65.4%
Uppercase_Letter	8	30.8%
Space_Separator	1	3.8%

Value	Count	Frequency (%)
Latin	25	96.2%
Common	1	3.8%

Value	Count	Frequency (%)
ASCII	26	100.0%

Order State
Categorical

HIGH CARDINALITY

Distinct count	1089
Unique (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Inglaterra	6722
California	4966
Isla de Francia	4580
Renania del Norte-Westfalia	3303
San Salvador	3055
Other values (1084)	157893

Value	Count	Frequency (%)
Inglaterra	6722	3.7%
California	4966	2.8%
Isla de Francia	4580	2.5%
Renania del Norte-Westfalia	3303	1.8%
San Salvador	3055	1.7%
Nueva York	2753	1.5%
Distrito Federal	2559	1.4%
Texas	2446	1.4%
Nueva Gales del Sur	2370	1.3%
Santo Domingo	2211	1.2%
Other values (1079)	145554	80.6%

Length

Max length	36
Mean length	10.87261729
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	45	54.2%
Uppercase_Letter	30	36.1%
Control	2	2.4%
Other_Punctuation	2	2.4%
Dash_Punctuation	1	1.2%
Space_Separator	1	1.2%
Close_Punctuation	1	1.2%
Open_Punctuation	1	1.2%

Value	Count	Frequency (%)
Latin	75	90.4%
Common	8	9.6%

Value	Count	Frequency (%)
ASCII	58	100.0%

Order Status
Categorical

HIGH CORRELATION

Distinct count	9
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

COMPLETE	59491
PENDING_PAYMENT	39832
PROCESSING	21902
PENDING	20227
CLOSED	19616
Other values (4)	19451

Value	Count	Frequency (%)
COMPLETE	59491	33.0%
PENDING_PAYMENT	39832	22.1%
PROCESSING	21902	12.1%
PENDING	20227	11.2%
CLOSED	19616	10.9%
ON_HOLD	9804	5.4%
SUSPECTED_FRAUD	4062	2.3%
CANCELED	3692	2.0%
PAYMENT_REVIEW	1893	1.0%

Length

Max length	15
Mean length	9.62396756
Min length	6

Value	Count	Frequency (%)
Uppercase_Letter	20	95.2%
Connector_Punctuation	1	4.8%

Value	Count	Frequency (%)
Latin	20	95.2%
Common	1	4.8%

Value	Count	Frequency (%)
ASCII	21	100.0%

Order Zipcode
Real number (ℝ_≥0)

MISSING

Distinct count	609
Unique (%)	2.5%
Missing	155679
Missing (%)	86.2%
Infinite	0
Infinite (%)	0.0%

Mean	55426.13233
Minimum	1040
Maximum	99301
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	1040
5-th percentile	10009
Q1	23464
median	59405
Q3	90008
95-th percentile	98026
Maximum	99301
Range	98261
Interquartile range (IQR)	66544

Descriptive statistics

Standard deviation	31919.2791
Coefficient of variation (CV)	0.5758886244
Kurtosis	-1.48173452
Mean	55426.13233
Median Absolute Deviation (MAD)	28934.40503
Skewness	-0.1403113969
Sum	1376785127
Variance	1018840378

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
10035	648	0.4%
10009	550	0.3%
10024	541	0.3%
94122	526	0.3%
10011	463	0.3%
94110	407	0.2%
98105	406	0.2%
19140	386	0.2%
90049	368	0.2%
98103	366	0.2%
Other values (599)	20179	11.2%
(Missing)	155679	86.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1040	3	< 0.1%
1453	17	< 0.1%
1752	6	< 0.1%
1810	13	< 0.1%
1841	88	< 0.1%

Value	Count	Frequency (%)
99301	10	< 0.1%
99207	22	< 0.1%
98661	12	< 0.1%
98632	10	< 0.1%
98502	9	< 0.1%

Product Card Id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	118
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	692.5097635
Minimum	19
Maximum	1363
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	19
5-th percentile	191
Q1	403
median	627
Q3	1004
95-th percentile	1073
Maximum	1363
Range	1344
Interquartile range (IQR)	601

Descriptive statistics

Standard deviation	336.4468073
Coefficient of variation (CV)	0.4858369153
Kurtosis	-1.267493907
Mean	692.5097635
Median Absolute Deviation (MAD)	309.2081086
Skewness	0.1382546099
Sum	125011170
Variance	113196.4542

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 19. 21.5 36. 40.5 51. ... 1359.5 1360.5 1361.5 1362.5 1363. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
365	24515	13.6%
403	22246	12.3%
502	21035	11.7%
1014	19298	10.7%
1004	17325	9.6%
1073	15500	8.6%
957	13729	7.6%
191	12169	6.7%
627	10617	5.9%
1362	838	0.5%
Other values (108)	23247	12.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
19	64	< 0.1%
24	74	< 0.1%
35	65	< 0.1%
37	262	0.1%
44	305	0.2%

Value	Count	Frequency (%)
1363	650	0.4%
1362	838	0.5%
1361	529	0.3%
1360	357	0.2%
1359	492	0.3%

Product Category Id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	51
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	31.85145054
Minimum	2
Maximum	76
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	2
5-th percentile	9
Q1	18
median	29
Q3	45
95-th percentile	48
Maximum	76
Range	74
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	15.64006388
Coefficient of variation (CV)	0.4910314481
Kurtosis	-0.6032610083
Mean	31.85145054
Median Absolute Deviation (MAD)	13.94913209
Skewness	0.3616247994
Sum	5749792
Variance	244.6115983

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[ 2. 2.5 3.5 4.5 6.5 ... 72.5 73.5 74.5 75.5 76. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
17	24551	13.6%
18	22246	12.3%
24	21035	11.7%
46	19298	10.7%
45	17325	9.6%
48	15540	8.6%
43	13729	7.6%
9	12487	6.9%
29	10984	6.1%
37	2029	1.1%
Other values (41)	21295	11.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	138	0.1%
3	632	0.4%
4	67	< 0.1%
5	343	0.2%
6	328	0.2%

Value	Count	Frequency (%)
76	650	0.4%
75	838	0.5%
74	529	0.3%
73	357	0.2%
72	492	0.3%

Product Description
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	180519
Missing (%)	100.0%
Memory size	1.4 MiB

Product Image
URL

Distinct count	118
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

http://images.acmesports.sports/Perfect+Fitness+Perfect+Rip+Deck	24515
http://images.acmesports.sports/Nike+Men%27s+CJ+Elite+2+TD+Football+Cleat	22246
http://images.acmesports.sports/Nike+Men%27s+Dri-FIT+Victory+Golf+Polo	21035
http://images.acmesports.sports/O%27Brien+Men%27s+Neoprene+Life+Vest	19298
http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	17325
Other values (113)	76100

Value	Count	Frequency (%)
http://images.acmesports.sports/Perfect+Fitness+Perfect+Rip+Deck	24515	13.6%
http://images.acmesports.sports/Nike+Men%27s+CJ+Elite+2+TD+Football+Cleat	22246	12.3%
http://images.acmesports.sports/Nike+Men%27s+Dri-FIT+Victory+Golf+Polo	21035	11.7%
http://images.acmesports.sports/O%27Brien+Men%27s+Neoprene+Life+Vest	19298	10.7%
http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	17325	9.6%
http://images.acmesports.sports/Pelican+Sunstream+100+Kayak	15500	8.6%
http://images.acmesports.sports/Diamondback+Women%27s+Serene+Classic+Comfort+Bike+2014	13729	7.6%
http://images.acmesports.sports/Nike+Men%27s+Free+5.0%2B+Running+Shoe	12169	6.7%
http://images.acmesports.sports/Under+Armour+Girls%27+Toddler+Spine+Surge+Running+Shoe	10617	5.9%
http://images.acmesports.sports/Fighting+video+games	838	0.5%
Other values (108)	23247	12.9%

Value	Count	Frequency (%)
http	180519	100.0%

Value	Count	Frequency (%)
images.acmesports.sports	180519	100.0%

Value	Count	Frequency (%)
/Perfect+Fitness+Perfect+Rip+Deck	24515	13.6%
/Nike+Men%27s+CJ+Elite+2+TD+Football+Cleat	22246	12.3%
/Nike+Men%27s+Dri-FIT+Victory+Golf+Polo	21035	11.7%
/O%27Brien+Men%27s+Neoprene+Life+Vest	19298	10.7%
/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	17325	9.6%
/Pelican+Sunstream+100+Kayak	15500	8.6%
/Diamondback+Women%27s+Serene+Classic+Comfort+Bike+2014	13729	7.6%
/Nike+Men%27s+Free+5.0%2B+Running+Shoe	12169	6.7%
/Under+Armour+Girls%27+Toddler+Spine+Surge+Running+Shoe	10617	5.9%
/Fighting+video+games	838	0.5%
Other values (108)	23247	12.9%

Value	Count	Frequency (%)
	180519	100.0%

Value	Count	Frequency (%)
	180519	100.0%

Product Name
Categorical

HIGH CARDINALITY

Distinct count	118
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Perfect Fitness Perfect Rip Deck	24515
Nike Men's CJ Elite 2 TD Football Cleat	22246
Nike Men's Dri-FIT Victory Golf Polo	21035
O'Brien Men's Neoprene Life Vest	19298
Field & Stream Sportsman 16 Gun Fire Safe	17325
Other values (113)	76100

Value	Count	Frequency (%)
Perfect Fitness Perfect Rip Deck	24515	13.6%
Nike Men's CJ Elite 2 TD Football Cleat	22246	12.3%
Nike Men's Dri-FIT Victory Golf Polo	21035	11.7%
O'Brien Men's Neoprene Life Vest	19298	10.7%
Field & Stream Sportsman 16 Gun Fire Safe	17325	9.6%
Pelican Sunstream 100 Kayak	15500	8.6%
Diamondback Women's Serene Classic Comfort Bi	13729	7.6%
Nike Men's Free 5.0+ Running Shoe	12169	6.7%
Under Armour Girls' Toddler Spine Surge Runni	10617	5.9%
Fighting video games	838	0.5%
Other values (108)	23247	12.9%

Length

Max length	45
Mean length	35.12000399
Min length	5

Value	Count	Frequency (%)
Uppercase_Letter	25	37.9%
Lowercase_Letter	24	36.4%
Decimal_Number	10	15.2%
Other_Punctuation	4	6.1%
Math_Symbol	1	1.5%
Space_Separator	1	1.5%
Dash_Punctuation	1	1.5%

Value	Count	Frequency (%)
Latin	49	74.2%
Common	17	25.8%

Value	Count	Frequency (%)
ASCII	66	100.0%

Product Price
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	75
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	141.2325499
Minimum	9.989999771
Maximum	1999.98999
Zeros	0
Zeros (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	9.989999771
5-th percentile	31.98999977
Q1	50
median	59.99000168
Q3	199.9900055
95-th percentile	399.980011
Maximum	1999.98999
Range	1989.99999
Interquartile range (IQR)	149.9900055

Descriptive statistics

Standard deviation	139.732492
Coefficient of variation (CV)	0.9893788087
Kurtosis	23.31299748
Mean	141.2325499
Median Absolute Deviation (MAD)	102.813998
Skewness	3.19101957
Sum	25495158.68
Variance	19525.16932

Histogram
Dynamic Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
59.99000168	24820	13.7%
129.9900055	22372	12.4%
50	21035	11.7%
49.97999954	19298	10.7%
399.980011	17325	9.6%
199.9900055	15622	8.7%
299.980011	13729	7.6%
99.98999786	12433	6.9%
39.99000168	11201	6.2%
24.98999977	2339	1.3%
Other values (65)	20345	11.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
9.989999771	285	0.2%
11.28999996	271	0.2%
11.53999996	529	0.3%
14.98999977	593	0.3%
15.98999977	602	0.3%

Value	Count	Frequency (%)
1999.98999	15	< 0.1%
1500	442	0.2%
999.9899902	10	< 0.1%
599.9899902	21	< 0.1%
532.5800171	484	0.3%

Product Status
Boolean

CONSTANT
REJECTED

Distinct count	1
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

0	180519

Frequency Table

Value	Count	Frequency (%)
0	180519	100.0%

shipping date (DateOrders)
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	63701
Unique (%)	35.3%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

5/21/2015 15:34	10
10/30/2016 3:16	10
7/16/2015 10:14	10
10/8/2016 23:37	10
5/21/2015 10:19	10
Other values (63696)	180469

Value	Count	Frequency (%)
5/21/2015 15:34	10	< 0.1%
10/30/2016 3:16	10	< 0.1%
7/16/2015 10:14	10	< 0.1%
10/8/2016 23:37	10	< 0.1%
5/21/2015 10:19	10	< 0.1%
7/5/2017 10:59	10	< 0.1%
11/6/2015 23:55	10	< 0.1%
7/19/2016 5:41	10	< 0.1%
9/10/2015 20:19	10	< 0.1%
1/4/2017 17:11	10	< 0.1%
Other values (63691)	180419	99.9%

Length

Max length	16
Mean length	14.50194162
Min length	13

Value	Count	Frequency (%)
Decimal_Number	10	76.9%
Other_Punctuation	2	15.4%
Space_Separator	1	7.7%

Value	Count	Frequency (%)
Common	13	100.0%

Value	Count	Frequency (%)
ASCII	13	100.0%

Shipping Mode
Categorical

HIGH CORRELATION

Distinct count	4
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Standard Class	107752
Second Class	35216
First Class	27814
Same Day	9737

Value	Count	Frequency (%)
Standard Class	107752	59.7%
Second Class	35216	19.5%
First Class	27814	15.4%
Same Day	9737	5.4%

Length

Max length	14
Mean length	12.82396867
Min length	8

Value	Count	Frequency (%)
Lowercase_Letter	13	72.2%
Uppercase_Letter	4	22.2%
Space_Separator	1	5.6%

Value	Count	Frequency (%)
Latin	17	94.4%
Common	1	5.6%

Value	Count	Frequency (%)
ASCII	18	100.0%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

First rows

	Type	Days for shipping (real)	Days for shipment (scheduled)	Benefit per order	Sales per customer	Delivery Status	Late_delivery_risk	Category Id	Category Name	Customer City	Customer Country	Customer Email	Customer Fname	Customer Id	Customer Lname	Customer Password	Customer Segment	Customer State	Customer Street	Customer Zipcode	Department Id	Department Name	Latitude	Longitude	Market	Order City	Order Country	Order Customer Id	order date (DateOrders)	Order Id	Order Item Cardprod Id	Order Item Discount	Order Item Discount Rate	Order Item Id	Order Item Product Price	Order Item Profit Ratio	Order Item Quantity	Sales	Order Item Total	Order Profit Per Order	Order Region	Order State	Order Status	Order Zipcode	Product Card Id	Product Category Id	Product Description	Product Image	Product Name	Product Price	shipping date (DateOrders)	Shipping Mode
0	DEBIT	3	4	91.250000	314.640015	Advance shipping	0	73	Sporting Goods	Caguas	Puerto Rico	XXXXXXXXX	Cally	20755	Holloway	XXXXXXXXX	Consumer	PR	5365 Noble Nectar Island	725.0	2	Fitness	18.251453	-66.037056	Pacific Asia	Bekasi	Indonesia	20755	1/31/2018 22:56	77202	1360	13.110000	0.04	180517	327.75	0.29	1	327.75	314.640015	91.250000	Southeast Asia	Java Occidental	COMPLETE	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	2/3/2018 22:56	Standard Class
1	TRANSFER	5	4	-249.089996	311.359985	Late delivery	1	73	Sporting Goods	Caguas	Puerto Rico	XXXXXXXXX	Irene	19492	Luna	XXXXXXXXX	Consumer	PR	2679 Rustic Loop	725.0	2	Fitness	18.279451	-66.037064	Pacific Asia	Bikaner	India	19492	1/13/2018 12:27	75939	1360	16.389999	0.05	179254	327.75	-0.80	1	327.75	311.359985	-249.089996	South Asia	Rajastán	PENDING	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/18/2018 12:27	Standard Class
2	CASH	4	4	-247.779999	309.720001	Shipping on time	0	73	Sporting Goods	San Jose	EE. UU.	XXXXXXXXX	Gillian	19491	Maldonado	XXXXXXXXX	Consumer	CA	8510 Round Bear Gate	95125.0	2	Fitness	37.292233	-121.881279	Pacific Asia	Bikaner	India	19491	1/13/2018 12:06	75938	1360	18.030001	0.06	179253	327.75	-0.80	1	327.75	309.720001	-247.779999	South Asia	Rajastán	CLOSED	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/17/2018 12:06	Standard Class
3	DEBIT	3	4	22.860001	304.809998	Advance shipping	0	73	Sporting Goods	Los Angeles	EE. UU.	XXXXXXXXX	Tana	19490	Tate	XXXXXXXXX	Home Office	CA	3200 Amber Bend	90027.0	2	Fitness	34.125946	-118.291016	Pacific Asia	Townsville	Australia	19490	1/13/2018 11:45	75937	1360	22.940001	0.07	179252	327.75	0.08	1	327.75	304.809998	22.860001	Oceania	Queensland	COMPLETE	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/16/2018 11:45	Standard Class
4	PAYMENT	2	4	134.210007	298.250000	Advance shipping	0	73	Sporting Goods	Caguas	Puerto Rico	XXXXXXXXX	Orli	19489	Hendricks	XXXXXXXXX	Corporate	PR	8671 Iron Anchor Corners	725.0	2	Fitness	18.253769	-66.037048	Pacific Asia	Townsville	Australia	19489	1/13/2018 11:24	75936	1360	29.500000	0.09	179251	327.75	0.45	1	327.75	298.250000	134.210007	Oceania	Queensland	PENDING_PAYMENT	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/15/2018 11:24	Standard Class
5	TRANSFER	6	4	18.580000	294.980011	Shipping canceled	0	73	Sporting Goods	Tonawanda	EE. UU.	XXXXXXXXX	Kimberly	19488	Flowers	XXXXXXXXX	Consumer	NY	2122 Hazy Corner	14150.0	2	Fitness	43.013969	-78.879066	Pacific Asia	Toowoomba	Australia	19488	1/13/2018 11:03	75935	1360	32.779999	0.10	179250	327.75	0.06	1	327.75	294.980011	18.580000	Oceania	Queensland	CANCELED	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/19/2018 11:03	Standard Class
6	DEBIT	2	1	95.180000	288.420013	Late delivery	1	73	Sporting Goods	Caguas	Puerto Rico	XXXXXXXXX	Constance	19487	Terrell	XXXXXXXXX	Home Office	PR	1879 Green Pine Bank	725.0	2	Fitness	18.242538	-66.037056	Pacific Asia	Guangzhou	China	19487	1/13/2018 10:42	75934	1360	39.330002	0.12	179249	327.75	0.33	1	327.75	288.420013	95.180000	Eastern Asia	Guangdong	COMPLETE	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/15/2018 10:42	First Class
7	TRANSFER	2	1	68.430000	285.140015	Late delivery	1	73	Sporting Goods	Miami	EE. UU.	XXXXXXXXX	Erica	19486	Stevens	XXXXXXXXX	Corporate	FL	7595 Cotton Log Row	33162.0	2	Fitness	25.928869	-80.162872	Pacific Asia	Guangzhou	China	19486	1/13/2018 10:21	75933	1360	42.610001	0.13	179248	327.75	0.24	1	327.75	285.140015	68.430000	Eastern Asia	Guangdong	PROCESSING	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/15/2018 10:21	First Class
8	CASH	3	2	133.720001	278.589996	Late delivery	1	73	Sporting Goods	Caguas	Puerto Rico	XXXXXXXXX	Nichole	19485	Olsen	XXXXXXXXX	Corporate	PR	2051 Dusty Route	725.0	2	Fitness	18.233223	-66.037056	Pacific Asia	Guangzhou	China	19485	1/13/2018 10:00	75932	1360	49.160000	0.15	179247	327.75	0.48	1	327.75	278.589996	133.720001	Eastern Asia	Guangdong	CLOSED	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/16/2018 10:00	Second Class
9	CASH	2	1	132.149994	275.309998	Late delivery	1	73	Sporting Goods	San Ramon	EE. UU.	XXXXXXXXX	Oprah	19484	Delacruz	XXXXXXXXX	Corporate	CA	9139 Blue Blossom Court	94583.0	2	Fitness	37.773991	-121.966629	Pacific Asia	Guangzhou	China	19484	1/13/2018 9:39	75931	1360	52.439999	0.16	179246	327.75	0.48	1	327.75	275.309998	132.149994	Eastern Asia	Guangdong	CLOSED	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/15/2018 9:39	First Class

Last rows

	Type	Days for shipping (real)	Days for shipment (scheduled)	Benefit per order	Sales per customer	Delivery Status	Late_delivery_risk	Category Id	Category Name	Customer City	Customer Country	Customer Email	Customer Fname	Customer Id	Customer Lname	Customer Password	Customer Segment	Customer State	Customer Street	Customer Zipcode	Department Id	Department Name	Latitude	Longitude	Market	Order City	Order Country	Order Customer Id	order date (DateOrders)	Order Id	Order Item Cardprod Id	Order Item Discount	Order Item Discount Rate	Order Item Id	Order Item Product Price	Order Item Profit Ratio	Order Item Quantity	Sales	Order Item Total	Order Profit Per Order	Order Region	Order State	Order Status	Order Zipcode	Product Card Id	Product Category Id	Product Description	Product Image	Product Name	Product Price	shipping date (DateOrders)	Shipping Mode
180509	PAYMENT	3	4	0.000000	335.980011	Advance shipping	0	45	Fishing	Caguas	Puerto Rico	XXXXXXXXX	Melissa	7	Wilcox	XXXXXXXXX	Corporate	PR	9453 High Concession	725.0	7	Fan Shop	18.359095	-66.079956	Pacific Asia	Guangshui	China	7	1/16/2016 6:49	26052	1004	64.0	0.16	65202	399.980011	0.00	1	399.980011	335.980011	0.000000	Eastern Asia	Hubei	PENDING_PAYMENT	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/19/2016 6:49	Standard Class
180510	PAYMENT	3	4	165.990005	331.980011	Advance shipping	0	45	Fishing	Caguas	Puerto Rico	XXXXXXXXX	Melissa	7	Wilcox	XXXXXXXXX	Corporate	PR	9453 High Concession	725.0	7	Fan Shop	18.359095	-66.079956	Pacific Asia	Guangshui	China	7	1/16/2016 6:49	26052	1004	68.0	0.17	65201	399.980011	0.50	1	399.980011	331.980011	165.990005	Eastern Asia	Hubei	PENDING_PAYMENT	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/19/2016 6:49	Standard Class
180511	DEBIT	2	2	157.429993	327.980011	Shipping on time	0	45	Fishing	Chula Vista	EE. UU.	XXXXXXXXX	Olivia	9314	Smith	XXXXXXXXX	Consumer	CA	3760 Stony Promenade	91911.0	7	Fan Shop	32.611141	-117.073662	Pacific Asia	Chengdu	China	9314	1/16/2016 6:28	26051	1004	72.0	0.18	65195	399.980011	0.48	1	399.980011	327.980011	157.429993	Eastern Asia	Sichuan	ON_HOLD	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/18/2016 6:28	Second Class
180512	DEBIT	6	4	86.400002	319.980011	Late delivery	1	45	Fishing	Caguas	Puerto Rico	XXXXXXXXX	Mary	7396	Madden	XXXXXXXXX	Home Office	PR	9918 Lazy Cape	725.0	7	Fan Shop	18.245256	-66.370621	Pacific Asia	Chengdu	China	7396	1/16/2016 6:07	26050	1004	80.0	0.20	65194	399.980011	0.27	1	399.980011	319.980011	86.400002	Eastern Asia	Sichuan	COMPLETE	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/22/2016 6:07	Standard Class
180513	PAYMENT	3	4	119.989998	299.989990	Advance shipping	0	45	Fishing	Lancaster	EE. UU.	XXXXXXXXX	Mary	3080	Smith	XXXXXXXXX	Home Office	OH	8600 Red Goose Abbey	43130.0	7	Fan Shop	39.715977	-82.599297	Pacific Asia	Shanghái	China	3080	1/16/2016 5:04	26047	1004	100.0	0.25	65185	399.980011	0.40	1	399.980011	299.989990	119.989998	Eastern Asia	Shanghái	PENDING_PAYMENT	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/19/2016 5:04	Standard Class
180514	CASH	4	4	40.000000	399.980011	Shipping on time	0	45	Fishing	Brooklyn	EE. UU.	XXXXXXXXX	Maria	1005	Peterson	XXXXXXXXX	Home Office	NY	1322 Broad Glade	11207.0	7	Fan Shop	40.640930	-73.942711	Pacific Asia	Shanghái	China	1005	1/16/2016 3:40	26043	1004	0.0	0.00	65177	399.980011	0.10	1	399.980011	399.980011	40.000000	Eastern Asia	Shanghái	CLOSED	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/20/2016 3:40	Standard Class
180515	DEBIT	3	2	-613.770019	395.980011	Late delivery	1	45	Fishing	Bakersfield	EE. UU.	XXXXXXXXX	Ronald	9141	Clark	XXXXXXXXX	Corporate	CA	7330 Broad Apple Moor	93304.0	7	Fan Shop	35.362545	-119.018700	Pacific Asia	Hirakata	Japón	9141	1/16/2016 1:34	26037	1004	4.0	0.01	65161	399.980011	-1.55	1	399.980011	395.980011	-613.770019	Eastern Asia	Osaka	COMPLETE	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/19/2016 1:34	Second Class
180516	TRANSFER	5	4	141.110001	391.980011	Late delivery	1	45	Fishing	Bristol	EE. UU.	XXXXXXXXX	John	291	Smith	XXXXXXXXX	Corporate	CT	97 Burning Landing	6010.0	7	Fan Shop	41.629959	-72.967155	Pacific Asia	Adelaide	Australia	291	1/15/2016 21:00	26024	1004	8.0	0.02	65129	399.980011	0.36	1	399.980011	391.980011	141.110001	Oceania	Australia del Sur	PENDING	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/20/2016 21:00	Standard Class
180517	PAYMENT	3	4	186.229996	387.980011	Advance shipping	0	45	Fishing	Caguas	Puerto Rico	XXXXXXXXX	Mary	2813	Smith	XXXXXXXXX	Consumer	PR	2585 Silent Autumn Landing	725.0	7	Fan Shop	18.213350	-66.370575	Pacific Asia	Adelaide	Australia	2813	1/15/2016 20:18	26022	1004	12.0	0.03	65126	399.980011	0.48	1	399.980011	387.980011	186.229996	Oceania	Australia del Sur	PENDING_PAYMENT	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/18/2016 20:18	Standard Class
180518	PAYMENT	4	4	168.949997	383.980011	Shipping on time	0	45	Fishing	Caguas	Puerto Rico	XXXXXXXXX	Andrea	7547	Ortega	XXXXXXXXX	Consumer	PR	697 Little Meadow	725.0	7	Fan Shop	18.290380	-66.370613	Pacific Asia	Nagercoil	India	7547	1/15/2016 18:54	26018	1004	16.0	0.04	65113	399.980011	0.44	1	399.980011	383.980011	168.949997	South Asia	Tamil Nadu	PENDING_PAYMENT	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/19/2016 18:54	Standard Class

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Missing values

Sample

First rows

Last rows